#! /bash/bin
db_name=fujunhua
hive -e "
use $db_name;

create table if not exists user_info(
user_id string comment '用户id',
remark string comment '栏目'
)
comment '用户信息表'
row format delimited
fields terminated by '\t'
lines terminated by '\n'
stored as textfile;

create table if not exists user_contents(
user_id string comment '用户id',
content string comment '内容',
sub_time string comment '发布时间',
reposts_count string comment '转发数量',
comments_count string comment '评论数量'
)
comment '微博数据表'
row format delimited
fields terminated by '\t'
lines terminated by '\n'
stored as  textfile;
"
